In SAS® Merchandise Allocation, the performance of seeding a worksheet degrades significantly when you specify the Special Calc 18 method option. The following error message might be generated in the log file:
>>> Info [DTM(Fri Jan 13 10:33:06 2017 : 3) TID(29524)
SRC(CSeedAllocation::GetNumOfNonZeroPeriodsForTimeRange) MSG(Special Calc 18:
select distinct time_id FROM MAXDATA.MINVENTORY where time_id in(
200801,200802,200803,200804,200805,200806,200807,200808,200809,200810,200811,200
812,200813,200814,200815,200816,200817,200818,200819,200820,200821,200822,200823
,200824,200825,200826,200827,200828,200829,200830,200831,200832,200833,200834,20
0835,200836,200837,200838,200839,200840,200841,200842,200843,200844,200845,20084
6,200847,200848,200849,200850,200851,200852 ) and location_id = 595 and merch_id
= 1 and merch_level = 1 and time_level = 51 and location_level = 4 and OH_ITEMS
> 0.0)]
>>> Info [DTM(Fri Jan 13 10:33:06 2017 : 3) TID(29524)
SRC(CSeedAllocation::HandleSpecialCalc) MSG(Special Calc 18: Count: 0.000000:
Target KPI: 72977)]
There is no workaround for this issue.
